UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLhw+o4MrkLsFYk456ucCf8WSyWhpaVBFMUxy/QJKwo='
WHERE
key_id = 'd773d839a8e03e01fedf81bb2a2447ba9c67ba9c2397642043ad678504d76587'
AND (
token = 'BLhw+o4MrkLsFYk456ucCf8WSyWhpaVBFMUxy/QJKwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)