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