UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MbW+0bvXlM/mGvn0svRLOqmy9jKdau92SVAvCGcIydM='
WHERE
key_id = 'a7767d0dbfa948bc5761f08e997303517fec42ddcd1d46e4a070746ab81a313d'
AND (
token = 'MbW+0bvXlM/mGvn0svRLOqmy9jKdau92SVAvCGcIydM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)