UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6TcrWDQdSbMkHh8m2hQjycY0qNzsD6Rc8S1ijMWpDs='
WHERE
key_id = '9a800c4cb8ba211ef9365b19854e45ba68f12be8d474026197ec555a7ce1f2a2'
AND (
token = 'r6TcrWDQdSbMkHh8m2hQjycY0qNzsD6Rc8S1ijMWpDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)