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