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