UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TBAcP0s3mPWGLtAv6tNhD88/MFHy/0EFEIa0d0xbmQ='
WHERE
key_id = '23f65930b95170809504412e2026c289edff95a7b857d918d8cb5c31900c7353'
AND (
token = '6TBAcP0s3mPWGLtAv6tNhD88/MFHy/0EFEIa0d0xbmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)