UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMQ4N5p9ITBUPNWg9f+6v7VsEY+RONj1Wi31kPJsG44='
WHERE
key_id = 'ca10b6237de269db7c7cbf19cd56d7a323e319e60265ff81507a18d6d6367bfe'
AND (
token = 'SMQ4N5p9ITBUPNWg9f+6v7VsEY+RONj1Wi31kPJsG44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)