UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/gXy5GC8ui1DRQ9ct56dRw4HqMwErYSt9iBK67fKhnA='
WHERE
key_id = 'be43bb1305c907161b07909761f6b84195ae411132058df7e6c8d08eca6490f8'
AND (
token = '/gXy5GC8ui1DRQ9ct56dRw4HqMwErYSt9iBK67fKhnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)