UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gA6flbnIb3zAjzpgFnvcKXVzKhZBfnWikIsYBirvBQk='
WHERE
key_id = 'c6bad86087cdc19f2f23904f8b6dc07fa086f09e3387a5d9cabd719e1c6fe5e8'
AND (
token = 'gA6flbnIb3zAjzpgFnvcKXVzKhZBfnWikIsYBirvBQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)