UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcbOo41gowR38zS7qL7LT10EtzQJ7R8Jn3iD47xa4SU='
WHERE
key_id = '460547c30a8503613410a5e4c9815194b4e6d3df80b162190a4c1b060cc7a5a4'
AND (
token = 'zcbOo41gowR38zS7qL7LT10EtzQJ7R8Jn3iD47xa4SU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)