UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5WKfOAzSsrgGDOh5g5PAKHlDjoNLWou20X1JnQ7Wgk='
WHERE
key_id = 'b46babf87304842f2bf38bc567c73527d6d698df9f3de15396aa4b1895eee086'
AND (
token = 'k5WKfOAzSsrgGDOh5g5PAKHlDjoNLWou20X1JnQ7Wgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)