UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abXQ7jfMXlUAFghADwpVbTZb9idTBB+11SmzTi+Iy50='
WHERE
key_id = '7f47fb9d4103deab770effc7e85d2402203a8ef7dd5b4372a7677ffaa6600ba2'
AND (
token = 'abXQ7jfMXlUAFghADwpVbTZb9idTBB+11SmzTi+Iy50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)