UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hC/qB16rA2HWnuNnrrJmFPFl5sYf/I7GlHr1ecnAT20='
WHERE
key_id = 'b214f4cf35c47a1bb6b2c381ec9c23b9fe14e7c2a72978b42f70c13bf000a81e'
AND (
token = 'hC/qB16rA2HWnuNnrrJmFPFl5sYf/I7GlHr1ecnAT20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)