UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaHS86VjT5UInrwi7mMIzd9apOI38ZcQj9TjD+SXDmw='
WHERE
key_id = 'bbd3fc10111d30196e7ecc76c046d2c4948cbea10eb5494d90a9ea6370c0279a'
AND (
token = 'qaHS86VjT5UInrwi7mMIzd9apOI38ZcQj9TjD+SXDmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)