UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ht3z8DNYh2jbIMrGfqGVJC4qysQweiB9mLqxxSp9bM='
WHERE
key_id = 'c719fd3db25739259e7db84c56929bc97c445ac112bab52f8c3937a5419b45d7'
AND (
token = '9ht3z8DNYh2jbIMrGfqGVJC4qysQweiB9mLqxxSp9bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)