UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g1KEsfl2SxrRF3B8haKd4maSmB88pcEhbALobfSo9Dw='
WHERE
key_id = '7e9171c47dbd44a8bfd9b429d5e020ec31c87d354b37add3947c22d985cf1aef'
AND (
token = 'g1KEsfl2SxrRF3B8haKd4maSmB88pcEhbALobfSo9Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)