UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXA+67aoFHzIA6zZgsaYQ//pJwfXSiz7XS19ovM+e5M='
WHERE
key_id = '4af2f518775e7178387f68b66148d9c53e65af5f0a1a824232d1aa680d14dae4'
AND (
token = 'LXA+67aoFHzIA6zZgsaYQ//pJwfXSiz7XS19ovM+e5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)