UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmQB+mJhjtnARrvmla7xpoI6FaakLFkf3GfZKDy92UA='
WHERE
key_id = 'f04dbeaf2a1a2cb7e381ccc8cb5f81107da1655ea87288b218ab168929c48d7f'
AND (
token = 'pmQB+mJhjtnARrvmla7xpoI6FaakLFkf3GfZKDy92UA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)