UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HcFEckwtxQyJJPVGIHkmdX5IS+xucxJO4ozDEOe020M='
WHERE
key_id = '269777e49a7073dc44a656846a052eb0a3d47c689f9812c4e50f9263860e33a6'
AND (
token = 'HcFEckwtxQyJJPVGIHkmdX5IS+xucxJO4ozDEOe020M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)