UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3K68bOJpG6UajjMyh9+XYv1tOpbFYjhBOu8D0kvxcy4='
WHERE
key_id = 'd383e715bb5cbc2f1c277c26e9a8c144b259b551ea4bf2aea852c0249be9ab49'
AND (
token = '3K68bOJpG6UajjMyh9+XYv1tOpbFYjhBOu8D0kvxcy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)