UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiSVzXCv+PlQh05g2cQnUfsU0Yl48u6fxj/AobdzkeA='
WHERE
key_id = 'c86800c35aa6a6b25b30112986b538185bfb4e792ce453e843a6a828cd996931'
AND (
token = 'QiSVzXCv+PlQh05g2cQnUfsU0Yl48u6fxj/AobdzkeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)