UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kJ9BK2ApXNQyOc2fgDdBQWwnieE1QP58I9FKpJHIfZ0='
WHERE
key_id = '1e861825a117db8e3311a14bc64fd2fc8823f1751c9d4965ab50c28d2415ab90'
AND (
token = 'kJ9BK2ApXNQyOc2fgDdBQWwnieE1QP58I9FKpJHIfZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)