UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nj5gxTts6Q77gp+k63fDjMbASkdhjRPQsC4Zp6jA008='
WHERE
key_id = 'b04c2c9b1a7630ae6300b90b9f4a3acc3d0d699add86c65d3fcce3613da0886e'
AND (
token = 'Nj5gxTts6Q77gp+k63fDjMbASkdhjRPQsC4Zp6jA008='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)