UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6V19GJciB5pIx9qxDhG/eGPvDDsjgywrEv5+P762xQ='
WHERE
key_id = 'd506986ddbe64cda7ff85c8fb8ccbef4a6b24518013cb4bab529e3fa9a47baab'
AND (
token = 'D6V19GJciB5pIx9qxDhG/eGPvDDsjgywrEv5+P762xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)