UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QWgeyrYAUMIKqQT16SOs4EFhoA27YYHegTV8Dy0w0uU='
WHERE
key_id = 'e4567e2daac9ea7c08208c46829e5b7af2cad78c32828bff309f7b3a50cfb9bb'
AND (
token = 'QWgeyrYAUMIKqQT16SOs4EFhoA27YYHegTV8Dy0w0uU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)