UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vg1HWTpwFcOxrQYm4bhlDX9yrld+UmlHM/H4q+o2JUY='
WHERE
key_id = 'c7c1a276686120c04ddf832668f5ce97e8e1803b40665a94db6feeba50f9b21c'
AND (
token = 'Vg1HWTpwFcOxrQYm4bhlDX9yrld+UmlHM/H4q+o2JUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)