UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1dFmENjbUcsTrtkG4WKNBay4PqA+4GJNrKBCQDtFNc='
WHERE
key_id = '9d8c7687a0419e9f9312e4f0af8b108273b85b812c6f00959af74921edee3a03'
AND (
token = 'c1dFmENjbUcsTrtkG4WKNBay4PqA+4GJNrKBCQDtFNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)