UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKxXR82surzG/OglkRzsRGUH8kjVFwZZAoVdyNi9XFE='
WHERE
key_id = '5d06538815dd69ef498208e2aa3bc36183c39b15661f64f6a67816b812a72942'
AND (
token = 'yKxXR82surzG/OglkRzsRGUH8kjVFwZZAoVdyNi9XFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)