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