UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnvkSuuM/vByNBQab9Xt5ofpmvnc6Vg4co7I7MWfeLY='
WHERE
key_id = 'ca0ba9f8426ef84478aa0f86a35f6807e11d49d99313540bf58b9bc73c83ed68'
AND (
token = 'ZnvkSuuM/vByNBQab9Xt5ofpmvnc6Vg4co7I7MWfeLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)