UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '869ACghWb+3ahYpfzkZhzNn7760OOJI+PVf4Zjzmpps='
WHERE
key_id = 'a6ffcda7a573d49b029899950f6b95642ab7eb390398193d9335b15d8bf050cc'
AND (
token = '869ACghWb+3ahYpfzkZhzNn7760OOJI+PVf4Zjzmpps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)