UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GQAIOaHpZRE3so2NuHxDHuGA1neCTu/JnC/e6g/U698='
WHERE
key_id = 'ccd3175d53a4e36c0f45f9079f9a997cab9b6d667359394b7501d884a3c063cd'
AND (
token = 'GQAIOaHpZRE3so2NuHxDHuGA1neCTu/JnC/e6g/U698='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)