UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcnghhXUrfuRLaVqRHGkimo6YfnRUs181GQ+x/F6Aoc='
WHERE
key_id = 'b2e4787feac1a6efc9a3e16b496e55686b4d396ee1e39dd9ed0dffd37f38e978'
AND (
token = 'ZcnghhXUrfuRLaVqRHGkimo6YfnRUs181GQ+x/F6Aoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)