UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vd1qxASUyRwYW2yASlvWLFRwq0FX927+XgV0YaGNdVg='
WHERE
key_id = '2b4ccc792e208d94a05e240a266e13daa63fea07b242f9a85c0e018c1b164881'
AND (
token = 'Vd1qxASUyRwYW2yASlvWLFRwq0FX927+XgV0YaGNdVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)