UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9o+ggPP0PhSgO6PjweHxljihBADfWMdqgEBhmSa1G8I='
WHERE
key_id = '214ca8ef2c2fc752f605819d8176859d2d24fd6c5e5b981914deb6b077e427ab'
AND (
token = '9o+ggPP0PhSgO6PjweHxljihBADfWMdqgEBhmSa1G8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)