UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0h9lPNtPF7WxIlLwb0FLFdjLl4h67qW+HUzREwiWwMs='
WHERE
key_id = 'a670e22b1959b2763efb170d46e7ca529e19d2e17d058c785ec822871cd2f1c2'
AND (
token = '0h9lPNtPF7WxIlLwb0FLFdjLl4h67qW+HUzREwiWwMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)