UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UI6OyjoKiIdWBUi6U+VDkFfXEJRUmenh/3KUH5MJnw='
WHERE
key_id = '404a637668b028b60259f22293587cb11d97c2a9dbd9f22d72ca5f958df749de'
AND (
token = '9UI6OyjoKiIdWBUi6U+VDkFfXEJRUmenh/3KUH5MJnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)