UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K+JZcG2EOqQNFz4n26u4YOHMqp5gLqZ79j06q6V/tak='
WHERE
key_id = '290e9d6391fd44bcc2807e31dd557bbadf3ad014fb8a70e0e4639abc5eb8a929'
AND (
token = 'K+JZcG2EOqQNFz4n26u4YOHMqp5gLqZ79j06q6V/tak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)